Column | Data Type | Nullable | Default | Description |
TerritoryID | int | not null | | Primary key for SalesTerritory records. |
Name | dbo.Name | not null | | Sales territory description |
CountryRegionCode | nvarchar(3) | not null | | ISO standard country or region code. Foreign key to CountryRegion.CountryRegionCode. |
Group | nvarchar(50) | not null | | Geographic area to which the sales territory belong. |
SalesYTD | money | not null | ((0.00)) | Sales in the territory year to date. |
SalesLastYear | money | not null | ((0.00)) | Sales in the territory the previous year. |
CostYTD | money | not null | ((0.00)) | Business costs in the territory year to date. |
CostLastYear | money | not null | ((0.00)) | Business costs in the territory the previous year. |
rowguid | uniqueidentifier | not null | (newid()) | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. |
ModifiedDate | datetime | not null | (getdate()) | Date and time the record was last updated. |